Mega Code Archive - Oracle PLSQL

Trigger
1) A system trigger(AFTER CREATE ON DATABASE)
2) A trigger restricting updates
3) A Trigger to check the available room
4) After logon database trigger
5) Alter trigger to disable it
6) Autonumbering Trigger
7) Avoid the mutating table error
8) Cascade inserts into myStudent into session and lecturer
9) Change letter case in a trigger
10) Check new value before insert and update
11) Check user name in a trigger
12) Create a before delete trigger
13) Create a BEFORE INSERT trigger
14) Create a Before Row Trigger
15) Create a Before Statement trigger
16) Create a BEFORE UPDATE Trigger
17) Create a BEFORE UPDATE trigger on the emp table
18) Create a trigger with REFERENCING new AS
19) Create an after delete trigger
20) Create an AFTER INSERT Trigger
21) Create an After Row Trigger
22) Create an After Statement Trigger
23) Create an after update trigger
24) Create or replace trigger
25) Create tigger on wrapper table
26) Create trigger on a view
27) Creating a logonlogoff auditing system using system-level triggers
28) Creating a Trigger with cursor inside
29) Define trigger brefore all updataction actions
30) Define trigger to force all department names to uppercase
31) Disable a Trigger
32) Disable all triggers
33) Disable and enable a trigger
34) Drop a trigger
35) Empty trigger(before insert or update or delete)
36) Enable a Trigger
37) Enable all Triggers on a table
38) Enabling a Trigger sql
39) Example
40) Force all department names to uppercase in a trigger
41) Get system time in a before insert trigger
42) If ( updating or deleting ), if ( inserting or updating )
43) If updating and new value equals old value
44) Log a server error to a table
45) Log a server error with information on time, user name, database name
46) Log all triggerable action
47) Log all updatable actions
48) Log and audit data change
49) Log database logon to a table
50) Log drop trigger on table schema
51) Log insert, update, delete for a table
52) Log user name and system time in a trigger
53) Logging All Operatins Using Autonumbering
54) Logging All Operations
55) Logging INSERT Operations
56) Logging INSERT Operations With WHEN Conditions
57) Logon schema logon to a table
58) Logon trigger
59) Oracles syntax for creating a trigger based on two tables
60) Order of trigger firing
61) Output new and old value in a before update trigger
62) Reference old and new value by column in a before update Trigger
63) Save information about all errors in an after-servererror on database
64) Show errors for a trigger
65) Shows an illegal use of LOBs in a trigger
66) Simple AFTER update trigger
67) Submit a job for altering user in an after-create-database trigger
68) Submit job from a trigger
69) Templace for using trigger as a log method
70) These triggers demonstrate the use of the
71) This is an example of a DML trigger
72) This trigger sends messages over a pipe to record inserts into myStudent
73) This trigger uses predicates to log changes to the myStudent table
74) This trigger will raise an ORA-4091 mutating table error
75) Trigger for auditing
76) Trigger for database startup event
77) Trigger is autonomous and hence the changes will be logged even if the original transaction rolls back
78) Trigger on each row
79) Trigger on schema creation
80) Trigger to check inserting value
81) Trigger to check the employee count per department
82) Trigger to log the database shutdown
83) Trigger to log the schema altercation
84) Trigger Which Modifies a Mutating Table
85) Use an instead-of trigger
86) Use NDS to disable the trigger
87) Use RAISE_APPLICATION_ERROR in a trigger
88) Use Sequence in a trigger
89) Use sysdate and user function in a trigger
90) Use trigger to create autoincrement column
91) Use user-defined function in trigger